﻿CREATE TABLE [flcr].[DEVICE_CATEGORY_DEVICE_XREF] (
    [DEVICE_CATEGORY_DEVICE_XREF_ID] INT          NOT NULL,
    [AUDIT_USER]                VARCHAR (50) NOT NULL,
    [AUDIT_DTTM]                DATETIME     NOT NULL,
    [AUDIT_DTTM_TZ]             INT          NOT NULL,
    [AUDIT_MOD_USER]            VARCHAR (50) NOT NULL,
    [AUDIT_MOD_DTTM]            DATETIME     NOT NULL,
    [AUDIT_MOD_DTTM_TZ]         INT          NOT NULL,
    [ACTIVE_FLG]                BIT          NOT NULL,
    [PRIMARY_FLG]               BIT          NOT NULL,
    [DEVICE_CATEGORY_ID]             INT          NOT NULL,
    [DEVICE_ID]                 INT          NOT NULL
);

